package com.greenhouse.mapper.glogs;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

@Mapper
public interface LogsMapper {
    //创建日志表
    @Insert("CREATE TABLE ${name} (" +
            "id INT AUTO_INCREMENT PRIMARY KEY COMMENT '日志ID'," +
            "user_id INT COMMENT '操作用户ID'," +
            "action VARCHAR(255) COMMENT '操作内容'," +
            "log_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT '日志时间'" +
            ") COMMENT='操作日志表';")
    Integer createGreanhouserEnvironment(@Param("name") String name);
}
